3 visuals for webpage

This code will help produce the three visuals that are going to be a part of each equity tracker indicator webpage: regional map (tract level) of most recent data, chart of the most recent data, chart of trends over time.

If the indicator is available through a tract-level data set. Getting the data to a workable version may require some data transformation. To explore, clean, transform, and generate a final data set, please use the data-gen-tract-template. This script will generate an .rda for the map and an .rda for the charts. These data sets will be loaded in before the data visualization code.

Indicator Explanation

The cardiovascular disease mortality rate provides a way to understand a population’s overall health. Cardiovascular disease can be caused by diet, lack of exercise, smoking, and environmental risk factors. Differences between groups of people can highlight differing access to healthcare and public services, adequate nutrition, and living conditions, all which impact a population’s susceptibility to cardiovascular disease. For this measure, we are defining cardiovascular disease mortality as an age-adjusted rate of deaths per 100,000 due to cardiovascular disease, such as coronary heart disease, strokes, aortic disease, and peripheral arterial disease.

1. Map of most recent data

To map data in this form, there should be a value corresponding to each census tract. Depending on the year or source of the data, this could be about 700 rows for data at the 2010 census tract resolution, or about 900 rows for data at the 2020 census tract resolution.

Create Visual

Sources: Washington State Department of Health (DOH) 2016-20 Washington Tracking Network (WTN); U.S. Census Bureau, Geography Division 2020 TIGER/Line Shapefiles



Data call outs

  1. 200: The region’s average cardiovascular disease mortality rate (per 100,000)
  2. 230: Pierce County has the highest rate of deaths due to heart disease and stroke of PSRC’s four counties
  3. 770%: The rate is 770% higher in the census tract with the highest rate (644), compared to the census tract with the lowest (74) rates


Insights & Analysis

  • Kitsap County has the lowest cardiovascular disease mortality rate (165 per 100,000), followed by Snohomish (179), King (199), and Pierce (230)
  • The census tracts with the lowest cardiovascular disease mortality rate (per 100,000) are in West Seattle, King County (74); Bothell, Snohomish County (74); Bryant/View Ridge neighborhoods (Seattle), King County (78)
  • The census tracts with the highest cardiovascular disease mortality rate (per 100,000) are in the Auburn, King County (644); Kent, King County (493); Lakewood, Pierce County (473)



2. Facet of most recent data

Create Visual

Cardiovascular Disease Mortality

Age adjusted rate per 100,000

Washington Tracking Network, Washington State Department of Health, U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)

Data call outs

  1. 228: The cardiovascular disease mortality rate (per 100,000) for people living in census tracts with the highest concentration of people of color, 21% higher that in census tracts with the lowest concentrations of people of color
  2. 16%: In Pierce County, the number of heart disease and stroke-related deaths for areas with the highest concentration of low income households is 16% higher than the regional average
  3. 36: When comparing areas with the highest and lowest concentrations of limited English proficient households, King County has the largest gap of 36 deaths or a 20% difference


Insights & Analysis

  • The smallest difference in the cardiovascular disease mortality rate between areas with higher numbers of households with lower income is in King County (57 per 100,000), followed by Snohomish County (75), Pierce County (77), and Kitsap County (93)
  • The number of heart disease and stroke-related deaths is highest in census tracts with the highest concentration of people with disabilities in all the counties; however, the rate varies between 142 per 100,000 in Kitsap County to 195 per 100,000 in Pierce County
  • There is no noticeable relationship between heart disease and stroke-related deaths and the concentration of people with limited English proficiency
  • Census tracts with higher concentrations of households with families have higher rates of cardiovascular disease mortality in King and Pierce Counties, while there is no clear trend in Kitsap and Snohomish Counties



3. Facet of trend data

Create Visual

Cardiovascular Disease Mortality

Age adjusted rate per 100,000

Washington Tracking Network, Washington State Department of Health, U.S. Census Bureau, American Community Survey (ACS) 2020 5-Year Public Use Microdata Sample (PUMS)

Data call outs

  1. 81%: The gap in the regional cardiovascular disease mortality rate between census tracts with the highest and lowest concentrations of people of color increased in 2020, an 81% larger rate than in 2010
  2. 70: The gap in the rate between census tracts with the highest and lowest concentrations of households below 200% of the poverty line in 2020, a 9% decrease compared to 2010
  3. 164%: The gap in the number of heart disease and stroke-related deaths between census tracts with the highest and lowest concentrations of households with youth increased by 164% between 2010 and 2020


Insights & Analysis

  • For census tracts with the highest concentration of people of color, King County is the only county in the region where the cardiovascular disease mortality increased over the past decade (7% increase)
  • Although deaths related to heart disease and stroke have decreased over time for census tracts with the highest concentration of households below 200% of the poverty line in all counties, the rate has remained the highest in Pierce County (279 per 100,000) - compared to King County (233), Kitsap County (222), and Snohomish County (219)
  • For census tracts with the highest concentration of people with disabilities, Snohomish County is the only county in the region where the cardiovascular disease mortality rate has decreased, or improved, over time (-28 per 100,000), while the rate has slightly increased in Pierce County (+4 per 100,000), King County (+10 per 100,000), and Kitsap County (+11 per 100,000)



Transfer files

Copy files from Github > Y drive

Copy files from Y drive > website folder

Back to top of the page